Query Processing and Optimization in the Distributed Architecture using NoSql: a Banking System

The banking sector is one of the best examples who create Big Data with increasing transactions per second across the globe. Each bank is administered by the DBA (Database Administrator) as a technical in charge. DBA makes an arrangement in the branch to divert query from authorized user to the appropriate data repository. The SQL core Engine accepts input stream, processes and optimized to increase efficiency across the network. QO (Query Optimiser) and QE (Query Executor) is an important module that helps in the process. Due to the existing limitations of the system, a cloud based distributed architecture comprising of IaaS (Infrastructure as a Service), PaaS (Platform as a Service) and SaaS (Software as a Service) is used with NoSql. Hadoop and MangoDB are an example that still retains ACID (Atomicity, Consistency, Isolation, Durability) features of cloud environment. KeywordsDBA, NoSql, QO, QE, ACID, IaaS, PaaS, SaaS, MangoDB, Hadoop.